UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEIIYTwsSPSZwXP9F1kAa17i2aH76nwXRnrABenHyyU='
WHERE
key_id = '6ff7949a628d0945422989b69f8e509b2529108447428ebf32cd544390451d7a'
AND (
token = 'zEIIYTwsSPSZwXP9F1kAa17i2aH76nwXRnrABenHyyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)