UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qziQtRj7O/IWSwc5k+jqW8oXsMNUnctDpG8DoAI+wek='
WHERE
key_id = '9f0fc6e8585f17786dc15ef10b72c65a7a1a89e891bb406fb39d8677346c4d9b'
AND (
token = 'qziQtRj7O/IWSwc5k+jqW8oXsMNUnctDpG8DoAI+wek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)