UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MzKzqFb6eZ/D5lyTzkTVKwxorfrZ6l/prTjaSwZgGM='
WHERE
key_id = 'c9a309fbe9cbde740bb035f528db4efc8a3671ccc7f13ef93ca89c82cd09ca54'
AND (
token = '9MzKzqFb6eZ/D5lyTzkTVKwxorfrZ6l/prTjaSwZgGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)