UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9fcaFpT67PFdN4jHm04b2PlUrgz4r5avFv52wvl8O4='
WHERE
key_id = '2a1882f70aea4ca8e6d8f855a5b3f1835b23cc2e5514341e319eaf6a264e6914'
AND (
token = 'S9fcaFpT67PFdN4jHm04b2PlUrgz4r5avFv52wvl8O4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)