UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SfuCHiOk6bkDRVWZ1BN2kh7PM8ZqUz6ThM4oeYG9xDo='
WHERE
key_id = '4a67d9648f3367daf9a5cd07e9aa902652913100731c745ebd557b928ae8814c'
AND (
token = 'SfuCHiOk6bkDRVWZ1BN2kh7PM8ZqUz6ThM4oeYG9xDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)