UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/5fBjKEAh8E2BIdA2MhYNUeS67N1ds/3lrmXoxfxH0='
WHERE
key_id = 'd185b3e96250f221379a57d3618c9320f1075e3b4e2a2eb856aa2883e64fa760'
AND (
token = 'B/5fBjKEAh8E2BIdA2MhYNUeS67N1ds/3lrmXoxfxH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)