UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgLLCUW7Gj9jL3j8cl0gEaJJyGXThBSRYDQoSkUIWro='
WHERE
key_id = '9605d1c186000c428ccdd0b75228ddc4b9b128f3a1c06b9ab494d8ead96a17c1'
AND (
token = 'zgLLCUW7Gj9jL3j8cl0gEaJJyGXThBSRYDQoSkUIWro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)