UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1IR93pe/NtBTDF77S30tNpSMq7AHibzSq15aXwm3Hk='
WHERE
key_id = '7aa7ef6588e67ebcbfbd672bb47169e5cb9f7926a0496dbd87aa28958fbf9cc0'
AND (
token = 'R1IR93pe/NtBTDF77S30tNpSMq7AHibzSq15aXwm3Hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)