UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99XR5EMNWudTH3BMHpUg+CKpSRkw1dzW56fHN2SzkCU='
WHERE
key_id = 'a3f8d3c4af71b2699ea409c514fad0c32aa3109e87b0401c1654b1bd3c7897af'
AND (
token = '99XR5EMNWudTH3BMHpUg+CKpSRkw1dzW56fHN2SzkCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)