UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRP0pnnyqSCfI7eWq22b2Rd8OYMGJ+met4s1G2z8vUs='
WHERE
key_id = 'e7bdc6b07f9ee8e96c3f37848f903b526d0c85512afe0c1090bbcc35bd880c74'
AND (
token = 'lRP0pnnyqSCfI7eWq22b2Rd8OYMGJ+met4s1G2z8vUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)