UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GeQ1Br9eLNFQMishaEqU1oNFkA19cymMXtrZcBC5kg='
WHERE
key_id = 'b0fdbd2919fcc96fc3f8288e3bb47a16a16a72d2334cc690671541228b1bb0b7'
AND (
token = '9GeQ1Br9eLNFQMishaEqU1oNFkA19cymMXtrZcBC5kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)