UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47RIyLPopQmqUAsgYxJAKCCiNxKkOR2ohU7m9nzD508='
WHERE
key_id = '67cfe7b77cfd0ebcafd628b542022c4d1731b847d78be5c656244c88b3153e55'
AND (
token = '47RIyLPopQmqUAsgYxJAKCCiNxKkOR2ohU7m9nzD508='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)