UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rvA7eMszw4kJw/KoFIkyHIvtjFPPa4gjGj6wYdvih9M='
WHERE
key_id = 'e916559775c7f4706c1c140ea0402d56cc0a84223f09c23e55e8e4feb5fd6e6d'
AND (
token = 'rvA7eMszw4kJw/KoFIkyHIvtjFPPa4gjGj6wYdvih9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)