UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uIZUiWh/dRKVnWcetRwbapiqRceYnDxj0+x+Xd4+4Y0='
WHERE
key_id = '6bcee05631c5a1c45a8aa763428d3326b31a32289f09ced1fe7d3024f41f9ed2'
AND (
token = 'uIZUiWh/dRKVnWcetRwbapiqRceYnDxj0+x+Xd4+4Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)