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