UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RZ2NFnTgvHT9qg6/2dhqvZG2sUl49j4FIkaNwbX63BA='
WHERE
key_id = 'efa47958f6728be1c8e55d2b308afee9e993845dd47d82b5d06b3717a155647b'
AND (
token = 'RZ2NFnTgvHT9qg6/2dhqvZG2sUl49j4FIkaNwbX63BA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)