UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pr8qsfA/pafI/HnGHx9TYoh3sh9nyJvYecDm4/K+uKM='
WHERE
key_id = 'f09c5e052cb60cc6185d024c427ddd5c052961a74cadef091994e7eaf6673282'
AND (
token = 'pr8qsfA/pafI/HnGHx9TYoh3sh9nyJvYecDm4/K+uKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)