UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yI14BhCA1gqh1r8oRFJTn6sYaBjjklhJxw0sztr9fak='
WHERE
key_id = 'b1d11bb29528c41c4fc4e216b27d851b35b4cb68edb1d35fd7fdc068bebaeeee'
AND (
token = 'yI14BhCA1gqh1r8oRFJTn6sYaBjjklhJxw0sztr9fak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)