UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n4FXVWFimkSJtom7tAnj7ngexFoqL9TMUi4tISJGLw4='
WHERE
key_id = '812805f3bebc3bacd3e2797ded4bf0ea95df2ce708e2a094a80a8cb0a5fc480f'
AND (
token = 'n4FXVWFimkSJtom7tAnj7ngexFoqL9TMUi4tISJGLw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)