UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kBwG0UwqhTn7lO0RXi2QLhiwSN/D7S1k7aG5gkiasp8='
WHERE
key_id = '812c17743fd5dc42a56ab14b4b142b422d993181fe2ed86c5da3fd186b5d9ade'
AND (
token = 'kBwG0UwqhTn7lO0RXi2QLhiwSN/D7S1k7aG5gkiasp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)