UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jTgfr04o6pshLPSf8ab11ukDcjwpfDuNLCfUXZUcSYs='
WHERE
key_id = 'f364866570737fc30f23831533b7fc6a2ff1ee2c543632b33e2edb2a47fa87e6'
AND (
token = 'jTgfr04o6pshLPSf8ab11ukDcjwpfDuNLCfUXZUcSYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)