UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LCbK4xpUkyJZXt4a0EaGlN2apxrf9yoF0jb+AXonkIw='
WHERE
key_id = 'a9cd645d71331479b83312ea396ba4c150067c42aaee58d044b4316c59c65bd6'
AND (
token = 'LCbK4xpUkyJZXt4a0EaGlN2apxrf9yoF0jb+AXonkIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)