UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nqhyc15TmXq4D7F/PzBOTDt9LUKp4epswLHlpvwUsbA='
WHERE
key_id = 'caf2ee06c77ffe4e228121ccaf004c15965249a973f89a4e997c6243688f697f'
AND (
token = 'Nqhyc15TmXq4D7F/PzBOTDt9LUKp4epswLHlpvwUsbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)