UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uOtizsSYOWlnASrpc7HJCKNoRL7sZmrE10Gut5n0OrM='
WHERE
key_id = '7888a3c41bb92f27e6dcf7797cb3e356f386b48c3a219d7c7a86e5ec99e2fa65'
AND (
token = 'uOtizsSYOWlnASrpc7HJCKNoRL7sZmrE10Gut5n0OrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)