UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uGP4/A6ynxy0FhKht3EXubjFzNdPWMaLPIBDSyfA7YM='
WHERE
key_id = 'f99a682b1207f9e628297a3740984c698183859b49805b5fdfcde5a18856b87f'
AND (
token = 'uGP4/A6ynxy0FhKht3EXubjFzNdPWMaLPIBDSyfA7YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)