UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNY+hBoEkPT0cKNsZwlSsuAKvfU05R6gwxefeRsBYOs='
WHERE
key_id = 'fe93f3790ba057d9d21c56cff528e0ebe7f62fbb20f438b6bd003740473b16c2'
AND (
token = 'qNY+hBoEkPT0cKNsZwlSsuAKvfU05R6gwxefeRsBYOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)