UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eKokVaOkOEEMiT3VeRSUiCs7WSQM18Q/Zp21X6bWC10='
WHERE
key_id = '3e7eb457a40ea1b31123b75196557fbf7f8034314da6d0b64cf026851ce8cbce'
AND (
token = 'eKokVaOkOEEMiT3VeRSUiCs7WSQM18Q/Zp21X6bWC10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)