UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'paWv7NXoDrWctVEjLbPC7BuW0iSuL+iua+nkGy7nXz4='
WHERE
key_id = 'b601af90a1f5187eba51a8c8692bd85f0cc6b99f6bab0713acb7c1c3de8d522b'
AND (
token = 'paWv7NXoDrWctVEjLbPC7BuW0iSuL+iua+nkGy7nXz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)