UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/BF04aEgtuHLa0aDQ/e8l5xP7mDUrr7W1I1uiQ08Qg='
WHERE
key_id = '99724c77be3952b82ff1019dfecbaf971b7c3385a1b191f6505ab40b434a598c'
AND (
token = 'q/BF04aEgtuHLa0aDQ/e8l5xP7mDUrr7W1I1uiQ08Qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)