UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QA4s0BjzMXrXZLFvaOWyYpEFEIx2tImLSJnbibkoAw='
WHERE
key_id = '09e569ad899d1e976579ba9790c0a2d014172acedfe8c87248cf48c3ec747d24'
AND (
token = '8QA4s0BjzMXrXZLFvaOWyYpEFEIx2tImLSJnbibkoAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)