UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqig1qslUaC1Ntdd5H1dZ3L5KBesHGz4eRfDvn8Y7cI='
WHERE
key_id = 'c23d660d291a116c6c53be2581995db3e954c2bab70c1b8719df83dc88b976e8'
AND (
token = 'zqig1qslUaC1Ntdd5H1dZ3L5KBesHGz4eRfDvn8Y7cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)