UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oer9F8H+w99huoi/I9YHADDq/ZJmE70Y2W0AwEFwDKw='
WHERE
key_id = '275ec41819f7e2165c183b4322b68c3a348ccfba9edd1b1328c62f87b0aaa311'
AND (
token = 'Oer9F8H+w99huoi/I9YHADDq/ZJmE70Y2W0AwEFwDKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)