UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Ef/yvupYI8/ykyHGWD3NBdKy8k4aOiurJK/N95MfKk='
WHERE
key_id = 'cd1f3f9d981feb4c453bc67efbbcda1b373a3e1855eb0809d1d5dab1d7a9f86c'
AND (
token = '2Ef/yvupYI8/ykyHGWD3NBdKy8k4aOiurJK/N95MfKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)