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