UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dCcUywo/aFziknpJXFNxiqzC1/7uBUrc1r1oNKb5Vc='
WHERE
key_id = 'e4b2cc1322e038215b5ef17e88b9797652088bd9c505ce91c3469205ac30eb7b'
AND (
token = '7dCcUywo/aFziknpJXFNxiqzC1/7uBUrc1r1oNKb5Vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)